SelectSql()

Executes SQL statements.

Use this method to execute statements that return rows (SELECT statements).

Parameters

None

Examples

var Query;
Query = CRM.CreateQueryObj("Select * from company", "");
Query.SelectSql();
while (!Query.eof)
{
CRM.AddContent(Query("comp_companyid") + " = " + Query("comp_name")+" ");
Query.NextRecord();
}
Response.Write(CRM.GetPage());

Displays the company identifier and name field from the selected SQL query until the end of the query.